-- Create Database
-- ----------------------------------------------------------
CREATE DATABASE IF NOT EXISTS moss DEFAULT CHARACTER SET = utf8;

Use moss;

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `t_app`
-- ----------------------------
DROP TABLE IF EXISTS ` t_app `;
CREATE TABLE ` t_app `
(
    `id` bigint
(
    20
) unsigned NOT NULL AUTO_INCREMENT COMMENT '应用Id',
    ` app_id ` varchar
(
    200
) NOT NULL,
    ` name ` varchar
(
    200
) NOT NULL DEFAULT '' COMMENT '应用名称',
    ` owner_name ` varchar
(
    200
) NOT NULL DEFAULT '' COMMENT '负责人姓名',
    ` owner_id ` varchar
(
    200
) DEFAULT '0' COMMENT '负责人Id',
    ` project_name ` varchar
(
    200
) NOT NULL DEFAULT '' COMMENT '所属项目名称',
    ` project_key ` varchar
(
    200
) NOT NULL DEFAULT '0' COMMENT '所属项目Id',
    ` description ` varchar
(
    1000
) DEFAULT '' COMMENT '应用描述',
    ` gmt_create ` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
    ` gmt_modified ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    ` is_deleted ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
    ` status ` tinyint
(
    4
) DEFAULT '0' COMMENT '应用的状态 0-创建 1-开发中 2-运行中 3-已下线',
    ` take_over ` tinyint
(
    4
) DEFAULT '0',
    ` ops_owner_name ` varchar
(
    200
) DEFAULT NULL,
    ` ops_owner_id ` varchar
(
    200
) DEFAULT NULL,
    ` repo_url ` varchar
(
    1000
) DEFAULT NULL,
    ` bu_name ` varchar
(
    255
) DEFAULT NULL,
    ` spring_application_name ` varchar
(
    255
) DEFAULT NULL,
    ` spring_boot_version ` int
(
    2
) DEFAULT '0',
    ` spring_cloud_version ` int
(
    2
) DEFAULT '0',
    PRIMARY KEY
(
    `id`
)
    ) ENGINE=InnoDB AUTO_INCREMENT=287 DEFAULT CHARSET=utf8 COMMENT ='应用表';

-- ----------------------------
--  Records of `t_app`
-- ----------------------------
BEGIN;
INSERT INTO ` t_app `
VALUES
    ('1',
     'halo-moss',
     'halo-moss',
     '许进',
     'xujin',
     'halo',
     'Halo',
     '',
     '2019-02-27 02:23:42',
     '2019-04-21 10:15:04',
     '0',
     '2',
     '1',
     '韩令三',
     'lingshan.han',
     'https://github.com/SoftwareKing/Moss.git',
     'XX',
     'halo-moss',
     '2',
     '2'),
    (
     '2',
     'moss-sample-1.5.x',
     'moss-sample-1.5.x',
     '杜为极',
     'weiji.du',
     'BKCASHIER',
     'MOSS',
     '',
     '2019-02-27 02:23:42',
     '2019-04-21 10:15:27',
     '0',
     '2',
     '1',
     '叶张',
     'dingf.ye001',
     'https://github.com/SoftwareKing/Moss.git',
     '金融XX',
     'moss-sample-1.5.x',
     '1',
     '1'),
    (
     '3',
     'moss-sample-2.1.x',
     'moss-sample-2.1.x',
     '许进',
     'guojian.li',
     'MOSS',
     'MOSS',
     '',
     '2019-02-27 02:23:42',
     '2019-04-21 10:15:22',
     '0',
     '2',
     '1',
     '齐思宇',
     'daiying.qi',
     'https://github.com/SoftwareKing/Moss.git',
     '房XX',
     'moss-sample-2.1.x',
     '2',
     '2');
COMMIT;

-- ----------------------------
--  Table structure for `t_app_name`
-- ----------------------------
DROP TABLE IF EXISTS ` t_app_name `;
CREATE TABLE ` t_app_name `
(
    `id` bigint
(
    20
) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
    ` name ` varchar
(
    200
) NOT NULL DEFAULT '' COMMENT '应用名称',
    ` gmt_create ` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
    ` gmt_modified ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    ` is_deleted ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
    PRIMARY KEY
(
    `id`
)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT ='应用name表';

-- ----------------------------
--  Table structure for `t_dict_data`
-- ----------------------------
DROP TABLE IF EXISTS ` t_dict_data `;
CREATE TABLE ` t_dict_data `
(
    `id` int
(
    11
) NOT NULL AUTO_INCREMENT COMMENT '数据字典详细主键',
    ` dict_code ` varchar
(
    64
) CHARACTER SET utf8 NOT NULL COMMENT '数据字典分类标识',
    ` item_name ` varchar
(
    64
) CHARACTER SET utf8 NOT NULL COMMENT '数据字典详细名称',
    ` item_value ` varchar
(
    64
) CHARACTER SET utf8 NOT NULL COMMENT '数据字典详细值',
    ` item_desc ` varchar
(
    64
) CHARACTER SET utf8 DEFAULT NULL COMMENT '数据字典详细描述',
    ` item_sort ` int
(
    16
) DEFAULT NULL COMMENT '排序',
    ` gmt_create ` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
    ` gmt_modified ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    ` is_deleted ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
    ` status ` tinyint
(
    4
) DEFAULT '0' COMMENT 'COMMENT ''数据字典项启用状态，1：启用，0：未启用'',',
    PRIMARY KEY
(
    `id`
)
    ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE =utf8_bin COMMENT ='数据字典详细表';

-- ----------------------------
--  Records of `t_dict_data`
-- ----------------------------
BEGIN;
INSERT INTO ` t_dict_data `
VALUES ('1',
        'springBootVersion',
        '1.5.13.RELEASE',
        '1',
        '1.5.13.RELEASE',
        '0',
        '1970-01-02 00:00:00',
        '2019-03-15 17:44:15',
        '0',
        '1'), (
        '2',
        'springBootVersion',
        '2.0.7.RELEASE',
        '2',
        '2.0.7.RELEASE',
        '0',
        '1970-01-02 00:00:00',
        '2019-03-15 17:44:19',
        '0',
        '1'), (
        '3',
        'springCloudVersion',
        'Edgware.SR3',
        '1',
        'Spring Cloud Edgware.SR3',
        '0',
        '1970-01-02 00:00:00',
        '2019-03-15 17:44:27',
        '0',
        '1'), (
        '4',
        'springCloudVersion',
        'Finchley.SR2',
        '2',
        'Spring Cloud Finchley.SR2',
        '0',
        '1970-01-02 00:00:00',
        '2019-03-15 17:44:31',
        '0',
        '1'), (
        '5',
        'frameworkVerison',
        '1.1.8.RELEASE',
        '1',
        '1.1.8.RELEASE',
        '0',
        '1970-01-02 00:00:00',
        '2019-04-10 19:58:48',
        '1',
        '1'), (
        '6',
        'frameworkVerison',
        '2.0.0.RELEASE',
        '2',
        '2.0.0.RELEASE',
        '0',
        '1970-01-02 00:00:00',
        '2019-04-10 19:58:48',
        '1',
        '1'), (
        '11',
        'appFlickerRule',
        '当实例数小于2',
        '1',
        '当实例数小于2时闪烁',
        '0',
        '1970-01-02 00:00:00',
        '2019-03-19 13:44:36',
        '0',
        '1'), (
        '12',
        'scoringRules',
        '当实例数大于1',
        '1',
        '当实例数大于1给1颗星',
        '0',
        '1970-01-02 00:00:00',
        '2019-03-19 13:42:48',
        '0',
        '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_dict_type`
-- ----------------------------
DROP TABLE IF EXISTS ` t_dict_type `;
CREATE TABLE ` t_dict_type `
(
    `id` int
(
    11
) NOT NULL AUTO_INCREMENT COMMENT '数据字典分类主键',
    ` dict_name ` varchar
(
    64
) CHARACTER SET utf8 NOT NULL COMMENT '数据字典分类名称',
    ` dict_code ` varchar
(
    64
) CHARACTER SET utf8 NOT NULL COMMENT '数据字典分类唯一标识',
    ` status ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '数据字典分类启用状态，0：启用，1：未启用',
    ` gmt_create ` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
    ` gmt_modified ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    ` is_deleted ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
    PRIMARY KEY
(
    `id`
)
    ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE =utf8_bin COMMENT ='数据字典分类表';

-- ----------------------------
--  Records of `t_dict_type`
-- ----------------------------
BEGIN;
INSERT INTO ` t_dict_type `
VALUES ('1',
        'Spring Boot的版本',
        'springBootVersion',
        '0',
        '2019-03-12 02:36:02',
        '2019-03-14 14:17:10',
        '0'), (
        '2',
        'Spring Cloud的版本',
        'springCloudVersion',
        '0',
        '2019-03-12 02:36:42',
        '2019-03-14 14:17:27',
        '0'), (
        '3',
        'Summer Framework的版本',
        'frameworkVerison',
        '0',
        '2019-03-12 02:37:21',
        '2019-03-14 14:17:41',
        '1'), (
        '6',
        'App根据实例数闪烁规则',
        'appFlickerRule',
        '0',
        '2019-03-15 01:55:56',
        '2019-03-15 01:55:56',
        '0'), (
        '7',
        '评分规则',
        'scoringRules',
        '0',
        '2019-03-15 01:56:22',
        '2019-03-15 01:56:22',
        '0');
COMMIT;

-- ----------------------------
--  Table structure for `t_menu`
-- ----------------------------
DROP TABLE IF EXISTS ` t_menu `;
CREATE TABLE ` t_menu `
(
    `id` bigint
(
    20
) NOT NULL AUTO_INCREMENT,
    ` parent_id ` bigint
(
    20
) DEFAULT NULL,
    ` name ` varchar
(
    255
) DEFAULT NULL,
    ` parent_ids ` varchar
(
    255
) DEFAULT NULL,
    ` url ` varchar
(
    255
) DEFAULT NULL,
    ` roles ` varchar
(
    255
) DEFAULT NULL,
    ` sort ` int
(
    11
) NOT NULL DEFAULT '1',
    ` icon ` varchar
(
    255
) DEFAULT NULL,
    ` gmt_create ` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
    ` gmt_modified ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    ` is_deleted ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
    ` key ` varchar
(
    255
) NOT NULL,
    PRIMARY KEY
(
    `id`
)
    ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_menu`
-- ----------------------------
BEGIN;
INSERT INTO ` t_menu `
VALUES ('1',
        '0',
        '总览',
        '0',
        '/dashboard',
        'USER,ADMIN',
        '6',
        'dashboard',
        '1970-01-02 00:00:00',
        '2019-03-01 18:36:14',
        '0',
        'dashboard'), (
        '2',
        '0',
        '服务治理',
        '0',
        '/#/application',
        'USER,ADMIN',
        '5',
        'appstore',
        '1970-01-02 00:00:00',
        '2019-03-01 17:34:03',
        '0',
        'serviceMgmt'), (
        '5',
        '0',
        '平台管理',
        '0',
        '/#',
        'USER,ADMIN',
        '1',
        'hdd',
        '1970-01-02 00:00:00',
        '2019-04-04 04:12:52',
        '0',
        'projectMgmt'), (
        '6',
        '4',
        '推送记录',
        '0',
        '/switchCenter',
        'USER,ADMIN',
        '1',
        'code',
        '1970-01-02 00:00:00',
        '2019-01-03 16:21:07',
        '0',
        'switchPushLog'), (
        '10',
        '4',
        '开关管理',
        '0',
        '/switchCenter',
        'USER,ADMIN',
        '1',
        'key',
        '1970-01-02 00:00:00',
        '2019-01-03 11:01:32',
        '0',
        'switchManage'), (
        '11',
        '4',
        '机器管理',
        '0', null,
        'USER,ADMIN',
        '1',
        'database',
        '1970-01-02 00:00:00',
        '2018-12-10 14:04:18',
        '0',
        'machine'), (
        '12',
        '0',
        '系统管理',
        '0',
        '',
        'ADMIN',
        '1',
        'setting',
        '1970-01-02 00:00:00',
        '2018-12-10 14:15:55',
        '0',
        'sys'), (
        '13',
        '12',
        '菜单管理',
        '0',
        '/OSManage',
        'USER,ADMIN',
        '1',
        'profile',
        '1970-01-02 00:00:00',
        '2018-12-10 14:04:24',
        '0',
        'menuManage'), (
        '16',
        '5',
        '应用管理',
        '0',
        '/application',
        'ADMIN',
        '1',
        'euro',
        '1970-01-02 00:00:00',
        '2019-04-19 21:47:35',
        '0',
        'appAccept'), (
        '24',
        '2',
        '服务管理',
        '0',
        '/application',
        'USER,ADMIN',
        '5',
        'deployment-unit',
        '2019-02-22 03:21:10',
        '2019-04-19 21:49:06',
        '0',
        'serviceManage'), (
        '25',
        '2',
        '事件中心',
        '0',
        '/application',
        'USER,ADMIN',
        '0',
        'setting',
        '2019-02-25 03:22:10',
        '2019-02-25 03:22:24',
        '0',
        'eventLog'), (
        '26',
        '2',
        '实例管理',
        '0',
        '/application',
        'USER,ADMIN',
        '3',
        'ant-design',
        '1970-01-02 00:00:00',
        '2019-04-19 21:50:22',
        '0',
        'list'), (
        '27',
        '5',
        '项目列表',
        '0',
        '/application',
        'ADMIN',
        '2',
        'project',
        '2019-03-07 02:33:31',
        '2019-04-19 21:48:32',
        '0',
        'Project'), (
        '28',
        '12',
        '用户列表',
        '0',
        '/userMgmt',
        'USER,ADMIN',
        '0',
        'user',
        '2019-03-07 02:35:53',
        '2019-04-04 06:53:52',
        '0',
        'userMgmt'), (
        '30',
        '12',
        '数据字典',
        '0',
        '/remoteConfig',
        'ADMIN',
        '0',
        'appstore',
        '2019-03-13 03:10:28',
        '2019-03-13 03:10:28',
        '0',
        'remoteConfig'), (
        '31',
        '5',
        '注册中心',
        '0',
        '/registerCenterMgmt',
        'ADMIN',
        '0',
        'gateway',
        '2019-04-04 04:13:20',
        '2019-04-19 21:48:02',
        '0',
        'registerCenterMgmt');
COMMIT;

-- ----------------------------
--  Table structure for `t_project`
-- ----------------------------
DROP TABLE IF EXISTS ` t_project `;
CREATE TABLE ` t_project `
(
    `id` bigint
(
    20
) unsigned NOT NULL AUTO_INCREMENT COMMENT '项目Id',
    ` name ` varchar
(
    200
) NOT NULL DEFAULT '' COMMENT '项目名称',
    ` cname ` varchar
(
    200
) NOT NULL DEFAULT '' COMMENT '项目中文名称',
    ` key ` varchar
(
    200
) NOT NULL DEFAULT '0' COMMENT '项目key',
    ` owner_name ` varchar
(
    200
) NOT NULL DEFAULT '' COMMENT '负责人姓名',
    ` owner_id ` varchar
(
    200
) DEFAULT '0' COMMENT '负责人Id',
    ` description ` varchar
(
    1000
) DEFAULT '' COMMENT '项目描述',
    ` gmt_create ` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
    ` gmt_modified ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    ` is_deleted ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
    PRIMARY KEY
(
    `id`
)
    ) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8 COMMENT ='项目表';

-- ----------------------------
--  Records of `t_project`
-- ----------------------------
BEGIN;
INSERT INTO ` t_project `
VALUES ('1',
        '服务治理',
        '服务治理',
        'MOSS',
        '许进',
        'xujin',
        '服务治理',
        '2019-02-28 21:01:18',
        '2019-04-05 14:42:36',
        '0'), (
        '2',
        '中台项目',
        '中台项目',
        'HALO',
        '许进',
        'xujin',
        '',
        '2019-02-28 21:02:25',
        '2019-04-05 14:43:09',
        '0'), (
        '3',
        'PMO',
        'PMO',
        'PMO',
        '黎茂',
        'mao.li001',
        '',
        '2019-02-28 21:02:25',
        '2019-03-07 16:45:13',
        '1'), (
        '4',
        'XXXUED',
        'XXXUED',
        'UED',
        '王佳琳',
        'jialin.wang',
        '',
        '2019-02-28 21:02:26',
        '2019-03-07 16:45:17',
        '1');
COMMIT;

-- ----------------------------
--  Table structure for `t_register_center`
-- ----------------------------
DROP TABLE IF EXISTS ` t_register_center `;
CREATE TABLE ` t_register_center `
(
    `id` int
(
    11
) NOT NULL AUTO_INCREMENT,
    ` code ` varchar
(
    50
) COLLATE utf8_bin NOT NULL COMMENT '注册中心标识',
    ` url ` varchar
(
    100
) COLLATE utf8_bin NOT NULL COMMENT '注册中心url',
    ` desc ` varchar
(
    64
) CHARACTER SET utf8 DEFAULT NULL COMMENT '描述',
    ` status ` tinyint
(
    1
) NOT NULL COMMENT '1 运行,0 停用',
    ` gmt_create ` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
    ` gmt_modified ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    ` is_deleted ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
    ` name ` varchar
(
    50
) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY
(
    `id`
)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE =utf8_bin COMMENT ='注册中心表';

-- ----------------------------
--  Records of `t_register_center`
-- ----------------------------
BEGIN;
INSERT INTO ` t_register_center `
VALUES ('1',
        'sq',
        'http://eureka.springcloud.cn/eureka/',
        '社区注册',
        '1',
        '2019-04-04 04:28:11',
        '2019-04-05 18:54:45',
        '0',
        '社区注册'), (
        '4',
        'zj',
        'http://localhost:8071/eureka',
        '自己本地',
        '0',
        '2019-04-20 22:37:04',
        '2019-04-21 11:37:25',
        '0',
        '自己本地');
COMMIT;

-- ----------------------------
--  Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS ` t_user `;
CREATE TABLE ` t_user `
(
    `id` int
(
    11
) NOT NULL AUTO_INCREMENT,
    ` username ` varchar
(
    50
) COLLATE utf8_bin NOT NULL COMMENT '英文名唯一',
    ` name ` varchar
(
    50
) COLLATE utf8_bin NOT NULL COMMENT '中文名',
    ` password ` varchar
(
    50
) COLLATE utf8_bin NOT NULL COMMENT '密码',
    ` status ` tinyint
(
    1
) NOT NULL COMMENT '是否启用',
    ` gmt_create ` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
    ` gmt_modified ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    ` is_deleted ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
    ` email ` varchar
(
    255
) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY
(
    `id`
)
    ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE =utf8_bin COMMENT ='用户表';

-- ----------------------------
--  Records of `t_user`
-- ----------------------------
BEGIN;
INSERT INTO ` t_user `
VALUES ('1',
        'xujin',
        'xujin',
        'UUKHSDDI5KPA43A8VL06V0TU2',
        '0',
        '2019-03-06 20:23:50',
        '2019-03-08 19:15:35',
        '0',
        'Software_King@qq.com'), (
        '6',
        'admin',
        'admin',
        'UUKHSDDI5KPA43A8VL06V0TU2',
        '0',
        '2019-04-12 04:37:00',
        '2019-04-21 11:38:48',
        '0',
        'admin@qq.com');
COMMIT;

-- ----------------------------
--  Table structure for `t_user_app`
-- ----------------------------
DROP TABLE IF EXISTS ` t_user_app `;
CREATE TABLE ` t_user_app `
(
    `id` bigint
(
    20
) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
    ` mail_nick_name ` varchar
(
    200
) NOT NULL DEFAULT '' COMMENT '邮箱前缀名称',
    ` app_id ` varchar
(
    200
) NOT NULL DEFAULT '' COMMENT '应用名称',
    ` gmt_create ` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
    ` gmt_modified ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    ` is_deleted ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
    PRIMARY KEY
(
    `id`
)
    ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COMMENT ='应用name表';

-- ----------------------------
--  Records of `t_user_app`
-- ----------------------------
BEGIN;
INSERT INTO ` t_user_app `
VALUES ('38',
        'xujin',
        'halo-moss',
        '2019-03-10 05:46:39',
        '2019-04-05 01:31:23',
        '1'), (
        '39',
        'xujin',
        'loop_test',
        '2019-03-10 07:44:23',
        '2019-03-10 07:44:27',
        '1'), (
        '40',
        'admin',
        'halo-moss',
        '2019-03-11 22:45:05',
        '2019-03-11 22:45:07',
        '1'), (
        '41',
        'test',
        'halo-moss',
        '2019-03-12 00:03:39',
        '2019-03-12 00:03:51',
        '1'), (
        '42',
        'test',
        'loop_test',
        '2019-03-12 00:52:27',
        '2019-03-12 01:04:15',
        '1'), (
        '43',
        'admin',
        'loop_test',
        '2019-03-12 04:37:18',
        '2019-03-12 04:37:21',
        '1'), (
        '44',
        'admin',
        'loop_test',
        '2019-03-12 04:37:23',
        '2019-03-12 04:37:24',
        '1'), (
        '45',
        'admin',
        'loop_test',
        '2019-03-14 09:13:35',
        '2019-03-14 09:13:41',
        '1'), (
        '46',
        'test',
        'halo-moss',
        '2019-03-18 04:17:17',
        '2019-03-18 04:17:19',
        '1'), (
        '47',
        'xujin',
        'halo-moss',
        '2019-04-10 06:47:12',
        '2019-04-10 06:47:12',
        '0');
COMMIT;

-- ----------------------------
--  Table structure for `t_user_roles`
-- ----------------------------
DROP TABLE IF EXISTS ` t_user_roles `;
CREATE TABLE ` t_user_roles `
(
    `id` int
(
    11
) NOT NULL AUTO_INCREMENT,
    ` username ` varchar
(
    50
) COLLATE utf8_bin NOT NULL,
    ` role ` varchar
(
    50
) COLLATE utf8_bin NOT NULL,
    ` gmt_create ` timestamp NOT NULL DEFAULT '1970-01-02 00:00:00' COMMENT '创建时间',
    ` gmt_modified ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    ` is_deleted ` tinyint
(
    4
) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 已经删除',
    PRIMARY KEY
(
    `id`
),
    UNIQUE KEY ` ix_auth_username `
(
    `
    username
    `,
    `
    role
    `
)
                                                                  USING BTREE
    ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE =utf8_bin;

-- ----------------------------
--  Records of `t_user_roles`
-- ----------------------------
BEGIN;
INSERT INTO ` t_user_roles `
VALUES ('11',
        'admin',
        'ADMIN',
        '2019-03-06 20:24:51',
        '2019-03-07 16:27:54',
        '0'), (
        '12',
        'xujin',
        'ADMIN',
        '2019-03-08 05:15:41',
        '2019-03-08 19:16:52',
        '0'), (
        '13',
        'test',
        'USER',
        '1970-01-02 00:00:00',
        '2019-03-12 12:52:40',
        '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
